🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-16 🟡

🔹 [Stack] [Automation]
👤 Client: 🇺🇸 United States Member since 2026-04-15
💰 Price: $400
🚩 Problem: Automate data extraction from a VNC screen to Google Sheets for daily reporting.
📦 Existing: Not specified

Specifications:

[Stack] Python, VNC library (e.g., pyVNC), OpenCV, Google Sheets API
[Method] Develop a script that navigates through specific screens via VNC and captures screenshots.
[Format] Use OpenCV to process screenshots for data extraction.
[UI/UX] Not applicable; focus on backend automation.
[Security] Ensure secure handling of credentials (e.g., environment variables) for API access.
[Target] Daily data logging into Google Sheets.

Workflow:

1. Install necessary libraries: pyVNC, OpenCV, and Google Sheets API client library.
2. Write functions to connect to VNC server and navigate through specific screens.
3. Capture screenshots of designated areas using OpenCV.
4. Process screenshots for data extraction (e.g., OCR).
5. Format extracted data into a structured format suitable for Google Sheets.
6. Integrate with Google Sheets API to write the extracted data.